Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SizeFamilyID (FK)(PK) | A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. | ID_SZ_FMY | Identity | integer | SizeFamily(CO_SZ_FMY) |
SizeCode (PK) | A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRMA to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. | CD_SZ | Code6 | char(6) | |
TableCode | The first character of the size code as designated by the NRF (1-9). This first digit refers to the size table, for example 1=adult male clothing, 5=footwear and 7=home decorating accessories. Retailers using proprietary in-house size codes use a "0" size table. | ED_TB_SZ | Code2 | char(2) | |
TableName | The name of the size table code, eg size code 4=infant's and children's clothing. | NM_TB_SZ | Name | varchar(40) | |
Description | A description of the apparel cataegories encompassed within the size table code. | DE_TB_SZ | DescriptionShort | varchar(255) | |
ActualSizeCode | The last four characters of the NRF size code. This code uniquely identifies a particular size, eg dress size 12 or combination of sizes, eg pants, waist size 36, inseam 31. | ED_SZ_ACT | Code4 | char(4) | |
ActualSizeTypeDescription | A description of the industry convention typically used to signify the size to the customer, eg waist used for pants, body for coats, neck for shirts, chest for sweaters, etc. | DE_TYP_ACT_SZ | Name | varchar(40) | |
ActualSizeProportionDescription | The proportions typically used to measure this particular ITEM type, eg 36 (waist) x 31(inseam). | DE_PRPTN_ACT_SZ | DescriptionShort | varchar(255) | |